BusinessUnitGroupReportingPeriod

Entity Definition

Logical Name : BusinessUnitGroupReportingPeriod
Physical Name : CA_PRD_RP_BSN_UN

A record of the exact date & time that a particular BusinessUnit Group started and ended a particular calendar defined ReportingPeriod. Note that because at the leaf level, a BusinessUnitGroup is identifed at the BusinessUnit level this can apply to individual business units as well as aggregations of business units. So it provides maximum flexibility.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
ReportingPeriodID (FK)(PK) The unique system assigned identifier for a particular ReportingPeriod. ID_PRD_RP Identity integer ReportingPeriod(CA_PRD_RP)
BusinessUnitGroupID (FK)(PK) A unique system assigned identifier for a group of BusinessUnits. ID_BSNGP Identity integer BusinessUnitGroup(CO_BSNGP)
BusinessUnitID (FK) A unique retailer assigned identifier for an RetailStore, DistributionCenter or AdministrationCenter ID_BSN_UN Identity integer BusinessUnit(LO_BSN_UN)
StartsDateTime The date and time the ReportingPeriod started for the BusinessUnit TS_SRT AuditDateTime datetime
EndsDateTime The date and time the ReportingPeriod ended for the BusinessUnit TS_END AuditDateTime datetime
StartTransactionID (FK) A universally unique identifier (UUID) for the Transaction. This may be assembled from alternate key members. ID_TRN_SRT IdentityUUID char(32) PeriodOpenTransaction(TR_PRD_OPN)
EndTransactionID (FK) A universally unique identifier (UUID) for the Transaction. This may be assembled from alternate key members. ID_TRN_END IdentityUUID char(32) PeriodCloseTransaction(TR_PRD_CL)

Relationships

Parent Entity Verb Phrase Child Entity
PeriodCloseTransaction closes BusinessUnitGroupReportingPeriod
BusinessUnit is referenced by BusinessUnitGroupReportingPeriod
ReportingPeriod summarizes business at BusinessUnitGroupReportingPeriod
BusinessUnitGroup is periodically reported by BusinessUnitGroupReportingPeriod
PeriodOpenTransaction opens BusinessUnitGroupReportingPeriod
BusinessUnitGroupReportingPeriod defines period of BusinessUnitGroupEvent

Logical Views containing BusinessUnitGroupReportingPeriod

Logical View
Logical 02400 - Control Transaction Macro View
Logical 02430 - Control Transaction - Period Open Close View
Logical 03000 - Reporting - Macro View
Logical 03000 - Reporting - Macro View
Logical 06100 - Calendar View
Logical 07040 - Customer Segment Dependent Behavior
Logical 10102 - EnterpriseWeather